Merge cells

You can merge any number of cells on the current sheet.

When merging cells:

•The selected range becomes a single cell.

•Only the data from the upper-left cell of the range is saved.

•The formatting of the upper-left cell of the range is applied to the merged cell.

 

To merge cells, select them and do one of the following:

•On the Home tab, in the Cells group, click  Merge cells.

•When working in macOS, select Table > Merge cells command from the command menu.

•Right-click the selected cell range and run the Merge cells command from the context menu.

•Press Ctrl+Alt+M (Windows, Linux) or  Option+ Cmd+M (macOS).

Unmerge cells

You can only split those cells that have previously been merged.

To unmerge cells, select the cell created by merging and do one of the following:

•On the Home tab, in the Cells group, click  Unmerge cells.

•When working in macOS, select Table > Unmerge cells command from the command menu.

•Right-click the selected cell and choose Unmerge cells command from the context menu.

•Press Alt+Shift+M (Windows, Linux) or  Option+ Shift+M (macOS).

 

The data that is contained in the merged cell is placed in the upper-left cell of the resulting range. Cells in the range will retain the formatting of the merged cell.